<?php 
$conn = mysqli_connect('127.0.0.1','root','123456','cake2');
mysqli_query($conn,'SET NAMES UTF8');
$sql = 'SELECT * FROM cake';
$result = mysqli_query($conn,$sql);
$c = [];
while ($row = mysqli_fetch_array($result)) {
    array_push($c,$row);
}
 ?>
<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <script src="../../js/jquery-3.1.1.js"></script>
    <link rel="stylesheet" href="../../css/comment.css"/>
    <link rel="stylesheet" href="../../css/teatime.css"/>
    <link rel="stylesheet" href="../../css/header.css"/>
    <link rel="stylesheet" href="../../css/footer.css"/>
    <title>精致下午茶</title>
</head>
<body>
   <?php include '../order/header.php' ?>

    <div class="location">你的当前位置： 首页 > 精致下午茶 </div>

    <div class="middle">
        <div class="middle_left">
            <div class="ding1">
                <a href="../order/order.php">定制蛋糕</a>
            </div>
            <div class="ding2">
                <a href="">女士定制蛋糕</a>
            </div>
            <div class="ding2">
                <a href="">男士定制蛋糕</a>
            </div>
            <div class="ding2">
                <a href="">儿童定制蛋糕</a>
            </div>
            <div class="ding2">
                <a href="">长辈定制蛋糕</a>
            </div>
            <div class="ding1">
                <a href="../dessert/dessert.php">茶歇饮品桌</a>
            </div>
            <div class="ding2">
                <a href="">生日甜品桌</a>
            </div>
            <div class="ding2">
                <a href="">婚礼甜品桌</a>
            </div>
            <div class="ding1">
                <a href="teatime.php">精致下午茶</a>
            </div>
            <div class="ding2">
                <a href="">精致甜点</a>
            </div>
            <div class="ding2">
                <a href="">特色饮品</a>
            </div>
            <div class="ding1">
                <a href="../party/party.php">派对时刻</a>
            </div>
            <div class="ding2">
                <a href="">生日帽</a>
            </div>
            <div class="ding2">
                <a href="">蜡烛</a>
            </div>
            <div class="ding2">
                <a href="">餐盘</a>
            </div>
            <div class="ding2">
                <a href="">装饰品</a>
            </div>
            <div class="ding2">
                <a href="">优惠套装</a>
            </div>
        </div><!--middle_left-->
        <div class="middle_right">
            <div class="pic">
                <a href="">
                    <img src="../../images/order/pic.jpg" alt="" width="789"  height="302" border="0"/>
                </a>
            </div>
            <div class="size1">
                <div class="size2">
                    <div class="size21">材质：</div>
                </div>
                <div class="size3" id="size31">
                    <a href="">全部</a>
                </div>
                <div class="size3">
                    <a href="">鲜奶</a>
                </div>
                <div class="size3">
                    <a href="">慕斯</a>
                </div>
                <div class="size3">
                    <a href="">芝士</a>
                </div>
                <div class="size3">
                    <a href="">翻糖</a>
                </div>
                <div class="size3">
                    <a href="">巧克力</a>
                </div>
                <div class="size3">
                    <a href="">其它材质</a>
                </div>
            </div><!--size11 -->
            <div class="size1">
                <div class="size2">
                    <div class="size21">场合：</div>
                </div>
                <div class="size3" id="size32">
                    <a href="">全部</a>
                </div>
                <div class="size3">
                    <a href="">生日</a>
                </div>
                <div class="size3">
                    <a href="">新婚</a>
                </div>
                <div class="size3">
                    <a href="">祝寿</a>
                </div>
                <div class="size3">
                    <a href="">朋友聚会</a>
                </div>
                <div class="size3">
                    <a href="">商务聚会</a>
                </div>
                <div class="size3">
                    <a href="">西式点心</a>
                </div>
                <div class="size3">
                    <a href="">下午茶</a>
                </div>
            </div><!--size12 -->
            <div class="size1">
                <div class="size2">
                    <div class="size21">尺寸：</div>
                </div>
                <div class="size3" id="size33">
                    <a href="">全部</a>
                </div>
                <div class="size3">
                    <a href="">10寸以下</a>
                </div>
                <div class="size3">
                    <a href="">12-18寸</a>
                </div>
                <div class="size3">
                    <a href="">20寸以上</a>
                </div>
                <div class="size3">
                    <a href="">定制蛋糕</a>
                </div>
            </div><!--size13 -->
            <div class="size1">
                <div class="size2">
                    <div class="size21">价格：</div>
                </div>
                <div class="size3" id="size34">
                    <a href="">全部</a>
                </div>
                <div class="size3">
                    <a href="">100元以下</a>
                </div>
                <div class="size3">
                    <a href="">10-200元</a>
                </div>
                <div class="size3">
                    <a href="">201-300元</a>
                </div>
                <div class="size3">
                    <a href="">300元以上</a>
                </div>
            </div><!--size14 -->
            <div style="clear:both; height:10px;"></div>

            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 31) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 31) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="xiang.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 31) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan1-->
            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 32) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 32) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="bing.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 32) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan2-->
            <div class="yuan" style="margin-right: 0">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 33) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 33) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="fuyun.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 33) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan3-->
            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 34) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 34) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="xue.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 34) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan4-->
            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 35) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 35) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="bei.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 35) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan5-->
            <div class="yuan" style="margin-right: 0">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 36) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 36) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="hello.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 36) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan6-->
            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 37) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 37) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="gan.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 37) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan7-->
            <div class="yuan">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 38) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 38) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="tong.php"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 38) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan8-->
            <div class="yuan" style="margin-right: 0">
                <table width="245" border="0" align="center" cellspacing="0" cellpadding="0">
                    <tbody>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 39) {?>
                        <td align="center">
                            <a href="">
                                <img src="<?php echo ($c[$i])[1];?>"  width="180" height="171" alt=""/>
                            </a>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 39) {?>
                        <td height="25" align="center">
                            <div class="biaoti">
                                <a href="pin.html"><?php echo ($c[$i])[2];?></a>
                            </div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    <tr>
                        <?php for($i=0;$i < count($c);$i++){?>
                        <?php if($i == 39) {?>
                        <td height="20" align="center">
                            <div class="cun"><?php echo ($c[$i])[3];?></div>
                        </td>
                        <?php } ?>
                        <?php } ?>
                    </tr>
                    </tbody>
                </table>
            </div><!--yuan9-->

        </div><!--middle_right-->
    </div><!--middle-->

    <div class="box" id="box2" style="top: 250px;position:fixed; visibility: visible; right: 5px;">
        <a href="" target="_blank">
            <img src="../../images/join/qq.jpg">
        </a>
    </div>
    <div class="footer"></div>
    <script>
       $('.footer').load('../order/footer.html');
        $('.yuan table tbody').click(function(){
            var i = $(this).find('tr:eq(1) a').html();

                // open('../../php/detailist.php? id='+i+'')
                open('detail3.php? name='+i+'');//获取name所对应的名字
                console.log(i);
         })
    </script>

</body>
</html>